SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROC [dbo].[PReviewUPDATE]
@idUspevDocs INT,
@Comment VARCHAR(2000),
@Mark smallint
AS
SELECT idUspevDocs from Review where idUspevDocs=@idUspevDocs
UPDATE Review
SET
Comment=@Comment,
Mark=@Mark,
DateReview=GETDATE()
WHERE idUspevDocs=@idUspevDocs
GO
